SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483907 LIMIT 1 [ RunTime:0.000954s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483907 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793300,698078,800220,515056,554141,893432,976087,653506,313573,427760,549268,927185,538107,444625,414693,113718,911960,979680,349052,332720,765857,893613,783565,690565,290107,539294,276093,296053,904771,259218,863684,207672,891408,912598,171515,676100,107167,257427,190240,149764,894248,238032,525354,17885,991926,1013573,755182,647327,759304,403754,48160,314694,247109,965531,1042467,409525,709249,555386,166758,373788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]