SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553826 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553826 [ RunTime:0.003044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013639,539832,272154,668541,971120,317778,361890,437164,120820,966694,135454,276804,92225,485453,253028,650578,1010145,204492,634940,925191,398865,315310,302303,234581,571569,683487,241039,501518,624489,416734,192656,848467,140027,514863,170302,415509,558216,705834,978286,381341,253025,627834,413480,933486,673906,953599,60336,461003,332145,500542,170801,79675,35480,449799,692086,330737,114508,557718,34231,753091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]