SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194035 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194035 [ RunTime:0.002890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708077,628251,889763,556239,38065,736624,31024,1012870,502141,426825,642076,129281,682491,1024766,67060,97705,1046569,349864,182273,277503,711227,551293,804833,993560,702641,501327,511514,718473,333773,405752,136339,413617,21672,425982,522680,670190,298228,263643,634136,22863,689868,742942,79127,400562,143632,61240,424680,836418,159198,792892,939930,873590,509117,76447,415927,817148,77525,362970,241559,961090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004875s ]