SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100708 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100708 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568867,447708,39932,32481,835508,107460,263149,947659,79712,778661,635602,260211,827889,247863,1008623,930896,762620,296455,691934,226524,869521,80338,449557,679386,38576,644214,77048,641683,609548,120973,469300,836135,564149,152055,100473,430662,541976,15624,1023111,756763,52783,16334,513727,1011703,250872,605520,100417,162248,280556,273565,287283,150318,796982,17791,336545,271688,528676,146441,681218,554816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]