SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500150 LIMIT 1 [ RunTime:0.001169s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500150 [ RunTime:0.009711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610511,7553,15872,827423,49411,464261,562298,734176,669443,293853,622439,791677,732205,120103,260063,229437,956203,129130,897034,596096,185038,881476,871737,991063,23718,321991,1026232,595837,538970,97662,211858,799404,755663,410164,333037,998771,631819,31569,111782,901913,153241,204527,643001,405610,44305,264075,296530,543758,910859,771612,146808,948305,464530,394873,962726,567221,599902,329295,802871,436171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]