SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308180 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308180 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228434,273668,46152,161810,489643,445212,733405,127578,492965,840479,939087,238415,70677,698805,14097,885544,150785,1006264,71248,978687,621708,734322,633598,74862,490076,181091,553973,54358,378203,651244,80231,119604,233201,1033968,629832,573033,903296,785919,819278,1039404,47162,111775,385863,775354,249936,200990,338066,49709,197049,855739,995908,694056,385568,541968,1036482,291563,2885,316740,938715,916932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]