SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027495 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027495 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839860,1010396,242136,66994,479790,560672,428972,240100,636453,466904,25316,755391,431600,806608,142719,827276,1041550,468166,529598,790849,87546,1022743,86590,802267,188681,302184,111566,145122,606225,58995,611389,880038,858535,708561,818189,1000152,92111,63797,869823,905356,233618,624275,1048004,297816,494589,782839,341892,145050,635719,369077,831864,892350,832608,535576,718732,14418,6455,863851,941837,508567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]