SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040043 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040043 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729886,422909,501241,582389,66462,433389,620661,141655,693903,732892,983900,583161,726356,878258,768939,463570,125954,442788,601109,425629,412158,958333,982289,35749,355674,255791,789880,41291,258177,379328,220340,910797,1042601,855920,970923,357997,175850,276262,850418,697534,508012,794927,203615,607566,315290,474360,626904,318024,1016694,823233,983676,902830,193402,628665,49745,918035,660404,227609,988720,647318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]