SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046051 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046051 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154171,477740,165172,610540,844364,11635,65968,535436,750097,560734,366030,146775,674267,694939,370910,670079,860872,708584,222792,970591,808140,925006,107524,271141,906190,681551,298689,776395,397494,622949,107540,339847,377916,632175,771601,716188,304569,44403,606286,828850,126829,239605,71155,581222,791400,231980,331166,304258,208013,686607,318219,348156,380091,7066,193818,644548,841202,152944,315270,779844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]