SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243803 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243803 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610787,469909,814174,168630,792754,134215,739942,105700,816320,755096,391352,529545,663694,69354,529825,103719,224814,580150,654212,494916,166862,540509,32504,629812,215506,726172,838038,572009,867174,1005243,418206,734105,960443,284805,412531,771895,659342,570416,51864,856212,604708,340084,982764,720160,280090,829506,399107,421541,615420,796867,486052,985137,296131,429325,215559,78027,304718,633035,817826,87735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]