SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30568 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30568 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764506,707611,773824,867677,941506,559044,1022322,236428,139325,291862,402757,243131,127551,224782,91686,190550,7227,547525,110297,145515,887579,823039,503498,885324,434641,90306,453016,598095,280057,458516,116014,477201,708200,799841,343646,243281,884559,480133,535387,996891,315438,166090,805952,850407,577616,286576,998337,619759,521680,745209,506744,776498,631023,632303,536290,373853,277700,1036209,578027,1026445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]