SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026142 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026142 [ RunTime:0.002935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447478,877880,657330,380111,499072,118321,659161,562001,706419,347041,903129,522601,284057,818746,899803,830646,561302,870941,599126,43868,647292,805256,1034170,288525,331112,459752,777611,246515,951775,1029412,150628,441729,600152,490254,879828,383500,231115,919109,811343,209789,490171,349126,548490,310297,832231,607350,93914,902245,263271,255369,373183,233043,65717,866676,643578,667727,438628,601322,176721,633457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]