SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002782s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437916 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437916 [ RunTime:0.003284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147521,682122,533687,251852,147784,950514,929272,880589,479835,750971,222403,674977,792729,675120,887434,817588,260000,206863,353959,77720,830077,12965,221646,394709,362216,878833,15305,390137,88686,69989,916683,836403,962975,47342,138787,358911,86660,332911,849346,31265,118593,30868,852437,308442,951327,141069,1039549,166177,132469,295299,782183,453173,948780,147339,471432,441290,58980,55924,436670,37269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003064s ]