SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56803 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56803 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617719,485506,790273,326063,584962,287067,1021799,417436,874996,536523,593616,136744,1021422,254349,726557,299475,783372,109778,748393,721401,546038,841016,333449,539768,859886,664628,22500,358796,454666,971885,1016229,205292,564610,180412,949013,33431,1022409,255479,598378,403645,212263,1018668,919369,397145,569230,312118,167891,893609,120976,241535,383184,1042115,1005626,319668,45816,597909,210470,242175,729169,796087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]