SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50427 LIMIT 1 [ RunTime:0.004014s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50427 [ RunTime:0.002978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75801,442520,256855,500331,1027824,919972,700775,952634,253544,834853,728507,385439,131663,915289,97357,746365,810014,608439,117751,38661,52261,551215,449176,957661,281328,812951,234909,912805,100403,601105,400350,113208,255576,838847,197812,19536,221368,568579,3085,847805,792924,194956,179536,34537,75539,311225,604996,852052,6240,429081,280569,528670,239188,581830,500612,114184,734560,547670,267174,111393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]