SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003798 LIMIT 1 [ RunTime:0.000745s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003798 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342315,71958,158239,195956,334647,962510,931717,868060,276208,705794,676076,788991,191671,217948,644939,543126,353067,27714,565052,291084,522911,202297,131954,978960,342579,684703,700250,193885,132519,929263,497892,988744,476267,125715,433121,319719,233155,784511,632719,932957,215299,827970,634242,503204,732477,284048,218593,304400,753117,26205,326419,551770,957429,105947,419864,383816,259206,215961,483139,637002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]