SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417531 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417531 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78532,1048794,221120,31747,728598,445424,753678,429112,529656,500564,979738,922425,760061,723457,951229,441512,380445,246495,452032,710815,187188,251645,797083,185690,491209,650623,108173,76217,752716,1016726,541814,4223,831185,717198,772854,796955,430961,900351,1014938,400635,170161,305864,274846,580106,657768,983522,947651,146730,4657,950297,447007,561413,184841,587617,199103,476860,301869,851077,793985,257127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]