SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460180 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460180 [ RunTime:0.003164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915492,1017769,116687,376303,700134,949625,129835,174832,646426,969318,323827,56370,808955,404019,562790,580948,772094,353702,470695,426227,198151,272571,720049,70345,862542,100890,948361,837195,709698,3359,888776,679852,252933,505855,186339,27410,755504,160788,60102,1008027,159923,168021,797363,438143,949018,869936,386507,84921,417057,720850,643719,339825,500718,752847,847888,811577,179359,944739,431091,201576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]