SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146313 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146313 [ RunTime:0.001399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873530,494654,590233,754146,484794,839952,580062,593817,4252,449748,682532,988260,415724,593048,706982,191021,628751,872153,137761,842779,974627,138680,322458,615392,457749,975059,569282,427576,187121,156899,347166,690518,808145,642354,58605,836663,884394,176535,834896,926251,147696,52684,724567,632174,485003,472164,126059,387725,222233,246778,230156,263172,636009,576311,57156,408937,325312,688785,541369,181315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002462s ]