SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3896 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3896 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750101,254994,404653,333146,696180,837169,716120,1019180,235159,37286,360181,956495,453882,685853,276672,824921,739586,614619,834585,122571,277316,224742,42781,364939,613693,124122,108639,360103,18852,250290,145859,35880,16952,206779,1014568,894183,116834,804885,669580,1017519,345218,533285,745386,31642,219044,311662,416644,415417,778320,319111,452987,188479,746941,387571,861198,348136,837714,1001993,987234,140346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]