SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026855 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026855 [ RunTime:0.011104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731559,442164,312397,542363,145666,496191,437986,885699,175953,903374,1016657,480335,666676,144777,341295,131846,796036,392933,689424,141258,681767,91089,139403,382480,367209,379210,646025,533313,971591,23933,497772,668776,678375,779522,508781,60798,350529,774253,565052,252521,458947,487492,497143,322956,1036778,445190,1042171,539464,800683,455985,429080,602708,1032022,1026983,308952,370053,731401,432441,345238,689709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026855 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026855 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002106s ]