SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409763 LIMIT 1 [ RunTime:0.000700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409763 [ RunTime:0.004357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154057,62729,68556,605013,219839,58759,148140,892497,303906,570616,335456,539194,183536,986198,840750,327175,491100,331324,559492,440661,490159,910169,444554,645371,769483,733610,780505,576015,362666,220446,379211,385968,283284,1025253,199284,771200,353763,210802,78155,372845,662564,639372,115347,40199,803382,782448,708861,683271,70203,854276,27212,834232,253403,54554,1021165,123184,162790,139786,683493,28768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]