SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471043 LIMIT 1 [ RunTime:0.002522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471043 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659799,591510,399558,317832,1038289,89144,393367,555480,911194,940879,331204,290284,802035,957698,86243,209765,215801,211853,227154,854164,698103,475424,422587,138448,137291,32021,570606,317120,322648,1023675,776701,171288,1005652,860744,585371,658915,81188,457252,96463,265236,179502,728564,615742,312243,5852,922825,291013,326503,137660,578705,326145,188403,921711,113422,693746,632893,76927,910583,629388,697589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]