SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447808 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447808 [ RunTime:0.002597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412254,1012520,471967,96452,368026,950017,811756,605927,716592,387198,634511,293183,662505,852541,285366,696962,214248,201739,256317,514103,245525,129723,262002,370339,716798,683650,53232,700551,688044,923858,117610,22613,768199,75687,826579,240457,1016490,954740,832399,411882,116017,481507,734725,904708,1025965,28871,648591,1014254,116843,192245,141039,635186,527078,79264,874657,693654,79111,414872,560425,528042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003644s ]