SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047605 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047605 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28899,444396,577427,586011,17667,207216,679438,761576,864073,684801,724027,414089,291704,614064,210128,919581,928272,822862,171941,508075,692079,546500,821907,403210,359984,298222,768394,320505,264860,355616,345931,453485,877156,793252,726678,161639,868550,936395,168482,929462,349641,685047,813965,622339,1032846,5510,828949,789103,620923,714525,740410,231787,1046319,421087,1004868,980772,223587,239520,51936,899972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]