SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529290 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529290 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284247,952295,923154,839917,325549,108774,295570,854292,373035,934645,173632,912370,296925,988171,322795,179006,263280,603739,700273,1044657,460030,809236,900790,431973,986132,426247,70699,129415,569448,779326,434299,48076,970169,12525,186655,241488,442516,411169,296030,58185,128876,965763,673579,371540,121299,288623,192374,155904,656934,68310,1008928,810809,390353,701436,290287,38353,518645,687094,957769,870758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003377s ]