SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150012 LIMIT 1 [ RunTime:0.001202s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150012 [ RunTime:0.004486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039201,163286,33330,937402,467760,278437,63836,899910,851310,263361,685298,718117,228856,946580,895247,155440,423129,85086,286677,666695,794782,358911,405237,771745,849776,131736,887071,244585,512021,1015157,96227,16195,929886,551557,605188,43495,939928,806645,868468,586885,956823,332264,434612,413732,372182,795275,611047,318977,433928,781701,233541,63655,302008,559059,323297,1043258,33797,284621,1030062,47494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]