SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523708 LIMIT 1 [ RunTime:0.001439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523708 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918231,1001284,32798,56756,829339,598072,715028,200160,831220,1031088,209702,907522,932503,820220,164419,901005,900559,528801,547486,261693,977496,123922,394178,1041093,703686,818758,390396,377387,635962,582225,486870,537827,875785,332511,419060,215591,233571,1008075,28686,86771,93431,351858,284963,55093,529495,447343,249773,686227,306348,762526,500609,332715,696699,208935,1033668,296434,567026,322208,856542,541170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]