SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290801 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290801 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4397,756445,350378,432382,624640,271323,648085,1019977,949892,315186,771928,897974,636443,593565,415455,290707,936605,403464,243584,906774,440756,182957,101962,210203,119246,324370,370510,309486,566701,331760,702330,218370,795989,29861,570461,168340,622478,88400,640468,753067,239904,252980,300477,40015,1036471,362092,784312,953827,952714,100005,914669,790660,15063,329491,873965,184123,120776,258798,420880,862511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]