SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314451 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314451 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891056,1043514,200813,437101,674637,976084,722414,415944,1012905,164296,308614,285465,33710,612263,943990,538116,634629,652172,562721,481701,608193,214358,688777,275915,572377,552284,205878,472853,606736,338007,26433,318792,186540,852851,113672,98752,1043024,601341,486567,416036,179950,511031,718832,598485,682215,703457,831587,229614,573054,241494,428018,577076,321977,298364,98745,131182,488259,383691,432311,260574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]