SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348089 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348089 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437834,920841,1019829,267393,182606,686524,357137,78897,577187,618081,640228,945335,582682,106616,417276,352970,730655,741398,842939,334132,1010751,373015,981778,117751,588265,238989,99853,185238,714786,851246,25834,292658,43998,409408,1031955,520130,456787,676778,871449,272891,366676,981161,465123,600660,656698,371075,822439,347818,354787,770413,517437,859445,599017,922905,440034,677281,4921,407781,902668,111652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]