SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479817 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479817 [ RunTime:0.002982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669493,130406,671755,11267,384367,938209,489843,424302,944285,29622,916323,210520,561116,269178,268175,712572,786085,1023300,440211,831353,371864,305923,985124,901599,823324,449498,650792,1013770,375092,795657,454349,102313,968737,478898,894904,831552,1024198,858984,488779,493141,68493,779896,225320,13078,152909,349216,641009,200557,556563,508539,903376,856880,259368,974259,220590,215702,875764,582561,207135,841335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]