SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457354 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457354 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739580,438705,494569,608280,647433,86757,475858,392377,341800,256918,1016121,713623,458104,751913,938647,901953,544284,449201,154229,750369,215484,25529,179988,964042,1027951,741228,277411,736611,446628,140447,777973,805246,63363,880776,500396,604622,776358,316926,195249,246712,700370,486613,719427,568905,1021127,40212,520762,180701,619591,683041,207738,816995,264220,713190,787876,342071,318343,675364,51095,664769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001579s ]