SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419787 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419787 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426731,943547,415346,491508,496342,383157,889322,335367,481710,611537,558305,835031,951791,479868,238830,590897,873495,166843,527238,84991,430,419683,800278,28608,20528,46351,531167,709254,803408,979631,902295,426954,28368,650595,312622,66516,694797,978680,66601,678009,345265,348568,514489,1037516,185529,404042,527341,899591,1030372,402756,291999,386404,513962,281196,277180,111007,374483,78403,1001879,238537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]