SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 680303 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 680303 [ RunTime:0.002595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919020,299384,920511,848629,472667,254923,151230,738558,260207,331739,793783,203325,470783,119117,311610,672539,328382,542140,306115,353253,444363,984952,582218,666042,460150,311023,273371,116044,21318,217409,462692,225458,395761,100234,732859,86709,206746,145947,991914,330617,234131,490653,383798,488555,345756,1008854,626566,901304,2589,707843,22018,357085,399469,1043533,548485,882263,338747,458266,155925,315038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 680303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 680303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]