SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343905 LIMIT 1 [ RunTime:0.001675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343905 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442445,942328,190996,506541,248343,206700,147939,352932,282315,951822,186974,368029,325671,830102,719589,265624,143138,753769,379077,625374,432723,1044961,462894,179533,170803,712409,986648,207048,645924,775927,150198,104728,349402,795750,924792,241490,326668,55831,891584,791983,797420,556247,618045,432193,889190,124878,119347,12982,70781,380809,754064,331214,888484,758430,38397,54509,360020,965310,195763,201544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]