SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407409 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407409 [ RunTime:0.003054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034817,323651,825535,744945,404232,565979,325836,425373,56040,812418,336345,11944,449232,88519,63729,1001103,1022483,758638,127689,994727,603691,202777,989675,844317,676922,666177,269095,703184,516086,155833,474844,743728,661511,775500,668134,819955,800196,65736,981376,305082,167143,319750,840635,320696,762795,537088,595107,5457,582479,278394,363979,434700,58661,533612,891967,590598,503484,859626,522693,126559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]