SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204590 LIMIT 1 [ RunTime:0.001159s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204590 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994643,193888,687789,285226,479316,85506,386471,1035280,791572,966249,729053,402461,135961,65984,761539,387619,935459,410911,778916,690906,1007454,920736,410685,762003,288837,490748,168358,444061,806129,140835,646513,569405,651368,927013,518507,650736,454339,238089,797711,905469,90184,879756,464210,998821,372250,485285,926460,258094,866662,847569,8547,631582,36732,773333,82326,1039534,126717,34995,697218,114852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]