SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505695 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505695 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114052,35177,706236,272159,931612,672446,365512,709693,1037454,371304,967426,641527,1032595,180484,127838,87758,481800,467955,849420,180139,4287,484997,569623,763839,418850,26829,1021997,364459,900147,834980,875225,215898,423232,461359,891628,215969,885760,334404,893044,451596,61545,320195,953859,206903,60718,940323,325724,229344,223204,894368,673513,949527,685898,983682,407056,457600,1048329,811176,994388,123359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505695 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505695 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]