SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483418 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483418 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503520,345903,863827,1028821,563710,245815,663166,653554,388791,720885,340365,311165,810908,327210,633327,200500,140820,916799,1474,798943,61666,567504,487491,602702,434735,360094,856489,1047922,155508,955134,931875,796183,643990,602468,157763,421616,120332,356414,730074,489267,960759,400105,375722,548150,1018963,938655,426817,664893,1037464,595318,230427,303919,539590,955206,834845,186326,595989,112270,557115,1011597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]