SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481951 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481951 [ RunTime:0.002269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499867,4991,756147,293274,453594,194130,774988,884812,903744,190830,445520,623382,893262,199790,850234,92058,240563,668488,146704,764607,256804,126312,115156,275773,86372,212547,850360,277758,335773,470698,209228,306457,1024067,694027,735382,145285,58083,300233,673855,749028,121367,1036896,252632,70619,930124,834855,812870,696455,768341,974169,982904,57199,149746,384932,92997,433219,356798,939210,441536,500949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001605s ]