SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463907 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463907 [ RunTime:0.003070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418081,706922,466709,1040091,738445,746520,1007251,577658,745183,29651,88347,208727,185685,951460,771115,153530,1023249,804725,991654,817386,190406,951772,751434,432769,88622,968463,835932,876087,637158,254644,162714,351730,925295,301112,737809,925391,949028,909936,704192,661732,43308,151974,352423,732279,902583,1048058,497154,922158,584146,828512,234089,17568,642018,1001316,229400,628952,620939,21546,296504,438030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]