SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467743 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467743 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483656,905137,880611,565608,445308,786721,1026044,380840,208269,413176,276950,436337,501614,641464,165818,871515,1003248,280185,668290,164188,256944,450315,659081,710388,287903,610277,382724,742080,390883,523590,644987,847646,418542,819167,211672,80787,954377,731597,986968,916949,171784,89098,797616,719133,1033391,96792,826984,501059,693886,132083,993211,303812,572499,202921,517555,570632,389164,593784,883205,305449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000799s ]