SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012969 LIMIT 1 [ RunTime:0.000657s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012969 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25400,277877,276577,104368,552237,140083,14827,230490,74198,469442,617831,359861,368845,798964,425590,749652,907167,216445,170564,549126,571017,622409,712388,279252,661921,416486,68679,919731,332623,913370,52478,460991,150603,811154,153747,463513,395041,831738,249828,101086,506301,188586,575537,445889,193883,236936,925137,996022,918790,121285,570404,96310,1033692,538998,580085,1036553,775127,797920,996756,21517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]