SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515881 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515881 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599760,429304,289973,940615,410987,159202,329965,19149,435973,829045,397326,460157,179355,616037,154272,737377,411597,469628,313579,751159,17733,955031,745888,1047090,1014883,982504,342447,50708,78483,332984,75176,525700,808532,567617,881851,259087,580599,1012503,676833,97259,218939,832241,2184,540396,313101,23140,524738,851965,542930,660012,893208,1006005,107125,874207,250068,519245,942611,312881,193120,800226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]