SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406723 LIMIT 1 [ RunTime:0.001066s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406723 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146638,1041623,515341,383638,190289,202789,173880,932969,836264,750669,965772,316403,397178,955360,326481,918555,363692,291985,41243,866823,522644,1010677,870149,176491,311185,693377,176148,356952,896793,90826,321053,304089,789022,385072,252002,552538,385784,970641,12236,35109,673157,701526,8883,223299,380396,781272,918351,893670,863793,777107,423521,360172,267842,1003311,753825,822424,495607,470184,679509,440306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]