SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540018 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540018 [ RunTime:0.002127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297022,566011,73904,148890,584972,335592,482181,287246,986875,22959,914922,243972,390859,376064,927133,554644,481328,222439,1760,372619,930980,763684,211995,575185,1031666,902608,669439,665886,907681,867693,381017,656332,811123,450662,677067,29826,912148,1015056,702585,382988,512428,128086,778720,15765,857580,478906,1025971,138867,275710,501265,429109,231664,388272,840887,285651,947936,500236,978251,313,944939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]