SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410643 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410643 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517925,342595,766349,991508,159255,594743,948132,214034,896900,689548,882564,267734,410262,1015738,944394,373467,884834,517097,795146,830042,1007778,189234,926998,57163,749064,858106,47342,429694,135124,380304,361073,631137,921489,652578,519320,720444,44755,151786,668135,289774,376306,316138,92612,635555,607938,843441,62671,928486,248464,105659,434813,15043,3087,278437,554894,393770,101021,284142,117408,487272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]