SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030101 LIMIT 1 [ RunTime:0.001654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030101 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102187,493696,544268,982287,659285,683017,1040123,758488,82641,737062,535285,884678,640574,594132,314606,528720,320266,824622,489935,805784,328700,148259,135766,915734,184406,35995,447469,176297,489294,930964,198643,435282,56670,745188,750517,209639,860274,429627,781479,64425,886029,146925,221123,673710,172802,40052,171985,574262,851251,870265,747427,345391,313411,837790,333393,417647,724735,383094,65180,909470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]