SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573791 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573791 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398441,510724,7202,597829,605943,767016,114047,362792,742156,941068,138262,490282,856198,514078,639798,831931,584264,711149,319622,362113,476477,1037041,440718,940389,32670,711755,531822,496718,476826,468222,757882,707975,112563,998594,237001,984391,736729,731991,42361,59551,782018,654787,736312,103275,382758,908048,314880,683576,771292,720993,587647,948580,517474,451100,331749,880293,915514,906095,840678,160013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]