SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001486 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001486 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587914,928704,841960,306038,531461,957550,549861,437303,35084,610095,511865,159093,697082,249353,790662,16092,341145,405981,1006302,288841,677832,688642,63086,149598,733377,801940,933925,1004754,505190,484611,673909,997523,737679,375993,447612,281789,561776,406489,198060,862611,209336,108128,537779,986999,440845,1043826,917145,952395,696252,650,789568,432661,407891,261962,761827,971907,625224,242441,143534,34993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]