SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505398 LIMIT 1 [ RunTime:0.001380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505398 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128283,898533,462065,46117,759453,988042,938853,622267,393036,377641,90369,568257,723417,959158,101936,398913,524670,489517,661410,619503,1038433,333188,502945,89141,807720,587857,749589,785679,380455,332284,953670,790231,523364,967480,318038,899170,749740,535320,159026,513971,337876,611768,558657,1026150,350668,115118,513385,778507,934606,865405,196950,590125,643562,949009,375490,76427,47590,563208,512218,50964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000935s ]