SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475723 LIMIT 1 [ RunTime:0.000646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475723 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447589,984272,869878,873267,995828,953848,93264,604810,136532,282480,14381,654633,115893,561430,728598,545998,638891,863888,242038,35388,1037948,585797,734529,50893,719437,205814,493618,29180,889834,607316,659856,1044203,229261,906977,247979,210990,1017399,157622,733763,9983,319596,482147,387723,588552,270004,432938,275470,844600,840450,393877,299016,88485,154195,740500,136253,754303,200503,307216,841783,717323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]