SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502508 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502508 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808134,64372,373908,50612,80254,702725,804944,398218,448220,533703,603288,516729,877102,751408,264508,995310,536451,807896,664242,187877,995292,613846,339841,943784,801274,554525,778226,833516,503551,337124,126701,116698,645821,650280,722353,535186,568420,741652,221841,754402,326394,939100,75783,372801,4148,911524,181747,148686,3339,65890,76471,849659,960012,44261,711899,90893,491801,915878,199884,748694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]