SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 272823 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 272823 [ RunTime:0.003981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200534,1015486,639523,299510,228689,964385,888300,97566,129151,229234,436903,457,976640,151374,610515,606663,780284,79616,238583,63419,469791,317782,19555,529238,762226,1044206,697858,339008,620097,390928,96691,955016,696991,788964,37081,388142,26123,388691,260777,139320,516809,791057,301997,842042,735062,754846,166476,414569,745749,915571,485235,953180,935391,68633,896162,457982,619133,334838,199842,746503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 272823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 272823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]