SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405159 LIMIT 1 [ RunTime:0.001966s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405159 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367314,778024,574160,632895,738127,910869,578450,94927,826291,889028,373987,140849,572837,18389,762385,499817,657872,761064,372248,169640,153809,987353,366829,975464,717037,779146,235765,344955,682119,820391,405204,547518,63623,809866,102704,102631,97801,373902,258845,523148,246521,1028926,449487,388094,1008502,310856,966418,484707,472741,36738,538415,870321,388487,610034,250188,1011071,373730,485910,1005204,872567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]