SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 702006 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 702006 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356544,966115,1010713,714152,737709,388734,1010777,312988,190203,342214,106912,173605,1016159,534477,419158,1024666,355569,708214,985778,1027421,932774,506735,181747,189372,487458,118878,756525,16335,146291,907177,293422,552278,872039,718294,704640,368158,572756,110303,615838,182284,667599,101212,950556,1048432,419829,569988,151831,979393,688642,406629,1025587,163701,472525,938046,373111,439974,905807,760555,865852,740542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 702006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 702006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]