SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598956 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598956 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504460,686762,909359,497187,744402,740704,457665,204512,448605,792594,1017832,787793,233196,409288,99159,384572,323833,50067,870484,1007236,171421,560867,210889,706832,531253,579942,931232,124755,385004,525315,587895,156718,384692,721428,43318,574609,741167,213514,580340,11782,517125,150854,305449,721872,776787,714511,479272,592233,922424,908767,745905,86580,930941,159999,245788,307549,180814,1012660,268138,240103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001925s ]