SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443726 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443726 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606458,237162,404951,818601,381666,217377,781750,638151,649737,327224,370825,37880,1029909,405575,49748,45294,144769,534945,35695,910177,978220,402477,913069,777767,591320,330725,207068,498563,1033861,582347,75372,988301,247734,804924,758062,746064,326495,521234,838184,224800,504890,742326,124548,872043,1044235,70311,112667,1020315,509786,418546,937819,1022241,174631,988332,359988,953990,336959,124547,805488,843222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]