SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19401 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19401 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680371,923180,86192,745673,512269,186875,560916,383672,738924,563367,435696,445097,577138,378439,771150,936240,837963,958601,872868,452657,84604,341841,317300,147941,693111,34846,164163,728091,755988,620156,281985,294725,41589,616843,158340,458292,1019893,348994,16643,109548,35839,711054,785596,920618,874771,350053,693869,889119,51122,910725,957340,235032,707610,666182,471014,360932,866212,384479,60007,881755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]