SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 705028 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 705028 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171508,497175,311235,473983,141212,106991,480364,714246,999115,867000,623371,104688,902370,605645,1039155,60397,763597,421712,438026,1020929,700333,91674,248713,567006,983080,139686,242362,287162,975294,794282,409814,673685,798160,121428,633614,228840,222740,318183,679738,504672,226911,189253,717882,842500,425348,704595,981945,987216,588163,527709,610556,802018,968627,623023,1023232,761124,245141,380424,596494,776978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 705028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 705028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]