SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012458 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012458 [ RunTime:0.003706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175327,670221,995681,438860,1008089,888413,891556,690771,639420,615567,737299,914849,681635,903933,927651,375014,446114,560635,521634,507711,466678,148192,821040,598711,216946,749807,886095,281152,997336,352696,454321,364145,602884,1040091,812613,337463,495573,954115,475779,858918,833344,163563,363540,290042,492449,789058,846623,961634,470520,854609,198458,756010,906537,455045,975029,408059,206938,1001455,1027492,152272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]