SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6812 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6812 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445725,295122,389800,790695,328715,1007166,109959,939482,278657,863563,791186,152032,112458,170082,181489,823909,394375,825520,325219,1014497,859867,391179,857675,767142,987658,266558,1022551,352500,176443,26727,724763,715052,884328,149092,953534,773133,243434,105625,33919,975866,760914,404782,157359,836903,148441,27037,144609,965222,906813,823423,553486,47032,429199,8442,260407,261293,223379,1029963,270465,532391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]