SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291120 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291120 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41301,920416,83418,576207,734476,373355,952756,515520,886631,311094,65100,715440,644335,216241,193906,195348,523215,682534,193104,492677,614947,36798,520118,162502,629503,516554,430733,361258,835269,1010368,435058,505856,372950,172184,762293,822196,820883,928755,340448,827651,203638,574831,932566,274184,1000152,215604,219710,401193,270003,30327,203675,651795,321583,486290,261893,655219,957649,1003161,183611,351743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]