SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354528 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354528 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747281,144390,717373,261336,596049,861053,619827,330434,48465,599308,616393,116213,360380,158593,21303,459476,741627,429063,699779,37574,639835,509385,550254,946897,647660,162665,202165,391207,801146,291499,1034320,904563,690851,381866,79877,382816,103460,986426,874363,739274,693432,786823,589879,898878,661954,982212,391275,956222,899659,81590,1033321,59588,964036,457805,792975,817412,647444,643322,500977,979807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]